/* sp_help_revlogin script 
** Generated 09 12 2012  2:14PM on LML-F3576C640AA */
 
DECLARE @pwd sysname
 
-- Login:  shenjx1
SET @pwd = CONVERT (varbinary(256), 0x0100F474A050D268F875C174472ED9CE319A03AF1CEAE323A0F4D268F875C174472ED9CE319A03AF1CEAE323A0F4)
EXEC master..sp_addlogin ' shenjx1', @pwd, @sid = 0x26463D7E0756814791414331C59DEA06, @encryptopt = 'skip_encryption'
 
-- Login: aduser
SET @pwd = CONVERT (varbinary(256), 0x0100974C1067900506E082205B0AE1643D0F11A8026D9471F518609FCBBB0CE1A1894177797D6491520A1DD632BF)
EXEC master..sp_addlogin 'aduser', @pwd, @sid = 0xABBB3AA062F0CA4BADA66ABC1C4A949A, @encryptopt = 'skip_encryption'
 
-- Login: AppUser
SET @pwd = CONVERT (varbinary(256), 0x0100882F157689975297C702FA8E527EBD2E86A0C9169037969688BA4F210822FBFDD35E6202C1A461BC1CBBF39F)
EXEC master..sp_addlogin 'AppUser', @pwd, @sid = 0xAAEB28ED0756A84A95C3FCA6F7776FD7, @encryptopt = 'skip_encryption'
 
-- Login: boadmin
SET @pwd = CONVERT (varbinary(256), 0x0100A92E5E60763EC20862F863A424E41E67BE95292E089E167440996D1788DE92B861CA22F271179C3F4431BD88)
EXEC master..sp_addlogin 'boadmin', @pwd, @sid = 0x445AE8DD1BA73B45B0B325BA0414FF33, @encryptopt = 'skip_encryption'
 
-- Login: bomcost
SET @pwd = CONVERT (varbinary(256), 0x0100AE6A9355346709A965E1DE1FACC5E127EB6E21239AD1B3B8D0C216919745B2C35BDAAAA05E3E4E47DC777B4B)
EXEC master..sp_addlogin 'bomcost', @pwd, @sid = 0xEC6B2887EC05584EB0A1BED12DC9ED3B, @encryptopt = 'skip_encryption'
 
-- Login: BUILTIN\Administrators
--EXEC master..sp_grantlogin 'BUILTIN\Administrators'
 
-- Login: caixyb
SET @pwd = CONVERT (varbinary(256), 0x0100AB295D506BE404B5F7C14866574B25BFFD157BB1020AFACBE01F5758760E5B07B9B8231C853728671FC96B17)
EXEC master..sp_addlogin 'caixyb', @pwd, @sid = 0xE47B85CE7693D44FA654EACB7065B976, @encryptopt = 'skip_encryption'
 
-- Login: checkdate
SET @pwd = CONVERT (varbinary(256), 0x01001857CE1644D01CD8FBD22B3792CEA7B23793E9379223F29844D01CD8FBD22B3792CEA7B23793E9379223F298)
EXEC master..sp_addlogin 'checkdate', @pwd, @sid = 0xEF1FD760D99D04459345EFBE1A52657D, @encryptopt = 'skip_encryption'
 
-- Login: cs_station
SET @pwd = CONVERT (varbinary(256), 0x0100EC4DAB2AD06BF505A247D3D311DB536D134673399D8258668B439B539488B21665F25CA514A14A016FF415FA)
EXEC master..sp_addlogin 'cs_station', @pwd, @sid = 0x3E101EABF960F541AB2A2CE69142422B, @encryptopt = 'skip_encryption'
 
-- Login: cswebuser
SET @pwd = CONVERT (varbinary(256), 0x0100477EC61669652D522DE85C056D36099A76F30AA8393C005B021D6F57C31C6CBE500E57A37D771F5E72AC1E22)
EXEC master..sp_addlogin 'cswebuser', @pwd, @sid = 0x74845B0DE075A24290CEBD8097A657A3, @encryptopt = 'skip_encryption'
 
-- Login: DBMonitor
SET @pwd = CONVERT (varbinary(256), 0x0100CC2C6169673B8FB8045DD32D9C889A2090F11E3D44385498C4B5FB062C1B6B20EC00247CD58CAE6629D25456)
EXEC master..sp_addlogin 'DBMonitor', @pwd, @sid = 0x2131075056612C4A97769529834C80E5, @encryptopt = 'skip_encryption'
 
-- Login: eservice
SET @pwd = CONVERT (varbinary(256), 0x0100016A3C3DAB18B006034E76FDEDCED056762DC1110D35816970A92E84805674F450E6EC53603438B09204E0E0)
EXEC master..sp_addlogin 'eservice', @pwd, @sid = 0x9609753C443A4F41944BD04119DAE0DE, @encryptopt = 'skip_encryption'
 
-- Login: excel_into
SET @pwd = CONVERT (varbinary(256), 0x0100455CCC4C141DABBB711F055712B3F1B7BB910EF909D95FA34B6306A1E2CA1E58B2A9A1BCC24CE8BE4008B0CA)
EXEC master..sp_addlogin 'excel_into', @pwd, @sid = 0xDB78D0868A6F38478F11AAA69A0E9DAF, @encryptopt = 'skip_encryption'
 
-- Login: guoxp
SET @pwd = CONVERT (varbinary(256), 0x0100A727E81B2CE32C2893CD7AB0106032E182904DFB1988D1C1DEF9E71F17418255CB6B015D5C4C58AC120A4679)
EXEC master..sp_addlogin 'guoxp', @pwd, @sid = 0xAD04BE518F48324393C1D456209BD476, @encryptopt = 'skip_encryption'
 
-- Login: hongqp
SET @pwd = CONVERT (varbinary(256), 0x01001A1EA25F31AF6B354B89AD74EDBECC1A9ECAA9B7FCE9ED11DBDF2898F1463075C60236EC36DC9D4D5B8A3B47)
EXEC master..sp_addlogin 'hongqp', @pwd, @sid = 0xADFECB09C2082B4E85308036EEF42274, @encryptopt = 'skip_encryption'
 
-- Login: huifang
SET @pwd = CONVERT (varbinary(256), 0x0100ED0A1C4DAA4A4ADC069FA9DA6B6D4D9A272EA1A46E33A46BAE7FF0366C94D2222AF3AA30C0D5878BEC792252)
EXEC master..sp_addlogin 'huifang', @pwd, @sid = 0x924AEAF9F528E04C971913F38646FC56, @encryptopt = 'skip_encryption'
 
-- Login: itsm
SET @pwd = CONVERT (varbinary(256), 0x0100BA66B240B3A0D750A3C159CE6F1CCF32685D83C50F3863C6289947B0DA4DE5A8A7150678C450AF6241730A7E)
EXEC master..sp_addlogin 'itsm', @pwd, @sid = 0xFF9736F11915434C8A64BC21275EF398, @encryptopt = 'skip_encryption'
 
-- Login: jiabao
SET @pwd = CONVERT (varbinary(256), 0x01008E1E4071790B78847E5E5DB3B247DE9C70CAE6FE57B0BF667B9384FB524F69E6B748BDDE7FF2EBAF15541423)
EXEC master..sp_addlogin 'jiabao', @pwd, @sid = 0x5B7E389EF43F644FA9C144972E2ED469, @encryptopt = 'skip_encryption'
 
-- Login: JianYan
SET @pwd = CONVERT (varbinary(256), 0x0100D129F46C68C6F7279A507CAA619DDED9142EC5B9BE0B7C1368C6F7279A507CAA619DDED9142EC5B9BE0B7C13)
EXEC master..sp_addlogin 'JianYan', @pwd, @sid = 0x4FAF58C91F370A4882D353D286588D30, @encryptopt = 'skip_encryption'
 
-- Login: jingyi
SET @pwd = CONVERT (varbinary(256), 0x0100B6183F1CF565D0BEB7A690FDE005D84D345ACA416E82B919175627049056D565BA8447FEB23F8A1099C5C12B)
EXEC master..sp_addlogin 'jingyi', @pwd, @sid = 0xB10F51790D4C894A9141F120EAE6C413, @encryptopt = 'skip_encryption'
 
-- Login: kefu
SET @pwd = CONVERT (varbinary(256), 0x01006D635C77AF58FE57297B8167CE5ABE27BAF3AFBB0CDB9D3FAF58FE57297B8167CE5ABE27BAF3AFBB0CDB9D3F)
EXEC master..sp_addlogin 'kefu', @pwd, @sid = 0x8316E04746B5354DAEE63A791579D40B, @encryptopt = 'skip_encryption'
 
-- Login: kunnr
SET @pwd = CONVERT (varbinary(256), 0x01009D4B8451EBED79BCEC6D29D76A72ED905FB9A2A1B514626C5FF40F69647B550082E32DD6CB521C3FFB1C0AC6)
EXEC master..sp_addlogin 'kunnr', @pwd, @sid = 0xC7A8C9711ECAAE49811479225FD79723, @encryptopt = 'skip_encryption'
 
-- Login: LEGEND
SET @pwd = CONVERT (varbinary(256), 0x010077452322ADAC990FE7FEDEC4274A8471A3247F33F54AF8DDADAC990FE7FEDEC4274A8471A3247F33F54AF8DD)
EXEC master..sp_addlogin 'LEGEND', @pwd, @sid = 0x19D365186DE8FC4F8AD6141F238AB2A0, @encryptopt = 'skip_encryption'
 
-- Login: legendsddbo
SET @pwd = CONVERT (varbinary(256), 0x01003363B651EA63B8C016F59156BDAE0661BA12DBDFBDF52D287201C8ADAA1EF72D8FCD2339DFAC1F73EA9DC649)
EXEC master..sp_addlogin 'legendsddbo', @pwd, @sid = 0x0392B1A61840AD4AA94AD4A45D880F47, @encryptopt = 'skip_encryption'
 
-- Login: lenhr
SET @pwd = CONVERT (varbinary(256), 0x0100450F12117E2149D1003187FD9FDB821503DC7FF823151638FB0A921BB93D0BCC2F78A324D2FFE9347F4E3B1F)
EXEC master..sp_addlogin 'lenhr', @pwd, @sid = 0xAC7F31E86F48B24682863E82A5A481C0, @encryptopt = 'skip_encryption'
 
-- Login: lenovojt_user
SET @pwd = CONVERT (varbinary(256), 0x0100CA66F077CC07B08507B4D949E9759781CE7943DB98488BE165F6DE1F7D35E0AAF5A1C2DB8B4165D40FC0A338)
EXEC master..sp_addlogin 'lenovojt_user', @pwd, @sid = 0xD59FED9916CFBC45B3B648E81B2E43E5, @encryptopt = 'skip_encryption'
 
-- Login: lenr3
SET @pwd = CONVERT (varbinary(256), 0x0100984F301FE34B674A688380043B941A55E3E3D7B031F9474A06BA2D71BEAA838E0B891FDD73E635964E18144A)
EXEC master..sp_addlogin 'lenr3', @pwd, @sid = 0x56CBF2165631C849AB1A52FCECBABC5E, @encryptopt = 'skip_encryption'
 
-- Login: linkfactory
SET @pwd = CONVERT (varbinary(256), 0x0100BA5BB96EF8EEA6766A34FB6172F05E62B0771BF487EE9FAA4B51F8615E0472A46ACE7463FB5401FC863F1C8F)
EXEC master..sp_addlogin 'linkfactory', @pwd, @sid = 0x733A3611CEC1DC45BF7764C7F9A11FD9, @encryptopt = 'skip_encryption'
 
-- Login: lixt
SET @pwd = CONVERT (varbinary(256), 0x01007B79FB599A461B0797AAB2C4D2F6FFC960FAAFC0C8D4FF7A45BDA48455F2D2F3C8EEB535DD891CE599862BAB)
EXEC master..sp_addlogin 'lixt', @pwd, @sid = 0x67C61CDFD89A2F4DB10A852AD0DC7999, @encryptopt = 'skip_encryption'
 
-- Login: lmlec
SET @pwd = CONVERT (varbinary(256), 0x010062479F0CD78292135221CAEE61B0F1CA399005A0C35A128C8993302742B4031D43596DDE8155C1143D60DEE3)
EXEC master..sp_addlogin 'lmlec', @pwd, @sid = 0x3FAB14AEE25500439B5C98998F645A20, @encryptopt = 'skip_encryption'
 
-- Login: LML-F3576C640AA\sqlserver
--EXEC master..sp_grantlogin 'LML-F3576C640AA\sqlserver'
 
-- Login: load
SET @pwd = CONVERT (varbinary(256), 0x01008B2774705E1297CE8624DF216EBDA95C5CFEA6CF0133ACE95E1297CE8624DF216EBDA95C5CFEA6CF0133ACE9)
EXEC master..sp_addlogin 'load', @pwd, @sid = 0x59D09146621E7744A9A3AFB63ABAC57C, @encryptopt = 'skip_encryption'
 
-- Login: malz
SET @pwd = CONVERT (varbinary(256), 0x010057480549657A58A5E476FD5F46B33E61A442595D0690FBEAF9F2B2DD637F6B8126C134787FDD306D02C42295)
EXEC master..sp_addlogin 'malz', @pwd, @sid = 0xC2C9E827FC83604F80D7433123E3C3FD, @encryptopt = 'skip_encryption'
 
-- Login: manhouruser
SET @pwd = CONVERT (varbinary(256), 0x0100AD4CFE33B68E79DA0E385C7E1ED00B541D4651B2278A300EB68E79DA0E385C7E1ED00B541D4651B2278A300E)
EXEC master..sp_addlogin 'manhouruser', @pwd, @sid = 0x90EEEF72BD772A4F9E5A2284E2B1E76D, @encryptopt = 'skip_encryption'
 
-- Login: mesuser
SET @pwd = CONVERT (varbinary(256), 0x0100C14FDA551E93E1F24B1BCDE8FAB0FCD59ACE29618B3242E563649048488C1F10671DA91D0BB08A9B4A615A4B)
EXEC master..sp_addlogin 'mesuser', @pwd, @sid = 0x725592D476CC33458E912F0692F3E332, @encryptopt = 'skip_encryption'
 
-- Login: pc
SET @pwd = CONVERT (varbinary(256), 0x0100A5591058714AD6737E94C1C4B40ECE2F8A63BA04136839A3E3BDE24C36B3F9B603AC406A037EE8BBA50270E9)
EXEC master..sp_addlogin 'pc', @pwd, @sid = 0x6B6B3CB4D692D847A5E61B887826E667, @encryptopt = 'skip_encryption'
 
-- Login: QASS
SET @pwd = CONVERT (varbinary(256), 0x01001C0ADF4BDA90372D233CFD0E493C2E80D26D29EB75C232DEDA90372D233CFD0E493C2E80D26D29EB75C232DE)
EXEC master..sp_addlogin 'QASS', @pwd, @sid = 0x9C6058432E683D4ABA1635F3B84E0E3A, @encryptopt = 'skip_encryption'
 
-- Login: rb
SET @pwd = CONVERT (varbinary(256), 0x01005B16C563D6E1233AE7118967FB4E4654590450768F6D041105AECCC58065045299ADA10CD510ECEA5C982EFE)
EXEC master..sp_addlogin 'rb', @pwd, @sid = 0x1D5AF8F960739644996B2C360A4DD20F, @encryptopt = 'skip_encryption'
 
-- Login: remoyiwei
SET @pwd = CONVERT (varbinary(256), 0x01005F39CF50A8D7ABA7766A824FF9FA8A71267CDDC656532244E4ACA795344F8FD9D0DAC97D33DC245F8F99AF87)
EXEC master..sp_addlogin 'remoyiwei', @pwd, @sid = 0xCE03A7806B2051429DE182AD153C4A39, @encryptopt = 'skip_encryption'
 
-- Login: shangwin
SET @pwd = CONVERT (varbinary(256), 0x01000927E03AF79DC21DE0F6DB87DE5A8A851FE5BC032AB3CEBA64E4AFAC7461C83D606278BF18C9BC1C458DBB4E)
EXEC master..sp_addlogin 'shangwin', @pwd, @sid = 0x4F4FAF9F4FF94843B7AE3CCCFB2F34E5, @encryptopt = 'skip_encryption'
 
-- Login: shenjx
SET @pwd = CONVERT (varbinary(256), 0x0100746DE1604C44553CDAE4B517C4AC23F094F53914F04416AB4C44553CDAE4B517C4AC23F094F53914F04416AB)
EXEC master..sp_addlogin 'shenjx', @pwd, @sid = 0x0E2C55EE5231F54CAFC6B4F2C54F9E2A, @encryptopt = 'skip_encryption'
 
-- Login: songhya
SET @pwd = CONVERT (varbinary(256), 0x0100A129FD72D31005641E4F21524E6619704233605D29668387D31005641E4F21524E6619704233605D29668387)
EXEC master..sp_addlogin 'songhya', @pwd, @sid = 0xCD0418B9DD38BC4186C18317CFDB3696, @encryptopt = 'skip_encryption'
 
-- Login: sqladmin
SET @pwd = CONVERT (varbinary(256), 0x0100F5494D079D5CFE42111B4286D008BF905310F890A02E345F9D5CFE42111B4286D008BF905310F890A02E345F)
EXEC master..sp_addlogin 'sqladmin', @pwd, @sid = 0x0A2A7E2EB6E5484C8926A06C133F2CA9, @encryptopt = 'skip_encryption'
 
-- Login: sw_trans
SET @pwd = CONVERT (varbinary(256), 0x0100F31942706A6ED6F60A8ADE39874545742C46D8DCC9DCAABA6A6ED6F60A8ADE39874545742C46D8DCC9DCAABA)
EXEC master..sp_addlogin 'sw_trans', @pwd, @sid = 0x3CD4823A6E976947A9A13810DC6B34CF, @encryptopt = 'skip_encryption'
 
-- Login: swwl
SET @pwd = CONVERT (varbinary(256), 0x0100114EE75F1F93B5132555B1876231B8DB778292934A62747AAEFC30D63823191DB4C506E5E02A97E6F2E318FB)
EXEC master..sp_addlogin 'swwl', @pwd, @sid = 0x2B7206D3C3619B4A800452FF4C63036F, @encryptopt = 'skip_encryption'
 
-- Login: test
SET @pwd = CONVERT (varbinary(256), 0x0100CB340D0930D045B7A5E0D26D93AF9BBE207972CFECBC26FA30D045B7A5E0D26D93AF9BBE207972CFECBC26FA)
EXEC master..sp_addlogin 'test', @pwd, @sid = 0x8D94D70761F9814BAB53BB04F09BEE2C, @encryptopt = 'skip_encryption'
 
-- Login: tmp
SET @pwd = CONVERT (varbinary(256), 0x0100D7252831BB32309E32D09EC1591028A9DEB0EAC168F69D55798F5CF0B77F0464B814D15ACFD4ECF7CF7A2852)
EXEC master..sp_addlogin 'tmp', @pwd, @sid = 0x7E9D77BC73306C41A756878E33E7EB72, @encryptopt = 'skip_encryption'
 
-- Login: unionsoft
SET @pwd = CONVERT (varbinary(256), 0x0100BE3B136FB151F0D264920D1FE220AC2E9A083C216FFB2CC0C5FC775077C48AFFA3055363B8AEF1A07BA200BF)
EXEC master..sp_addlogin 'unionsoft', @pwd, @sid = 0xC7CBC8E193485A448553F0D4CCEB0185, @encryptopt = 'skip_encryption'
 
-- Login: wspc
SET @pwd = CONVERT (varbinary(256), 0x01005733C62AC59089A32A5FB757F24643D0B21814E50B1BF1BC228C3FEB0B0FB9D7E70667619B1DDE888F06E767)
EXEC master..sp_addlogin 'wspc', @pwd, @sid = 0x85857B25BB8FFE4B9A97E5E2FDF01BCD, @encryptopt = 'skip_encryption'
 
-- Login: xiaojia
SET @pwd = CONVERT (varbinary(256), 0x01005C674B3AD848D4AA0F1230F4C486CCFF8C44E5355DAEB2711397DC7CBED50160C250C95E675F5EC75C59F9E4)
EXEC master..sp_addlogin 'xiaojia', @pwd, @sid = 0xD686739361A74849ACE32303DE3C0508, @encryptopt = 'skip_encryption'
 
-- Login: XINGJI
SET @pwd = CONVERT (varbinary(256), 0x0100866BD329CAE6472577DCE28234F13DF7CF3D099EC3D7B01FA09050872AFF3F503E2A86BB29967C5CBE740B1A)
EXEC master..sp_addlogin 'XINGJI', @pwd, @sid = 0xA8EAF7D957AEC7408EDE688C5383893F, @encryptopt = 'skip_encryption'
 
-- Login: xingjitmp
SET @pwd = CONVERT (varbinary(256), 0x0100994FE27108D7AB6646C404B1DF4D19D9860255AEB032887E418B49A5AF3FEDC1083E0789C0AE655F384C227E)
EXEC master..sp_addlogin 'xingjitmp', @pwd, @sid = 0x452B7A17B1DDE642B0F5B1487A235D4B, @encryptopt = 'skip_encryption'
 
-- Login: XJ
SET @pwd = CONVERT (varbinary(256), 0x0100AE58E17799466A4E764CEFB96FC2437943E87F64E94E4CCCBFDC7B4668754C18C9AAE34AE1F9F92F8EDD4A8F)
EXEC master..sp_addlogin 'XJ', @pwd, @sid = 0x87D53C1293E83C4D86134137CBCF88ED, @encryptopt = 'skip_encryption'
 
-- Login: xujk
SET @pwd = CONVERT (varbinary(256), 0x01002C6FB04DBFF243FB3BD8574BB9220A2BAC853BA4D84687200BBC9A31BD2F9422115E45A1715BABFD2479E7E5)
EXEC master..sp_addlogin 'xujk', @pwd, @sid = 0x61DBF0CB5806DA459691BC3C5DCC9175, @encryptopt = 'skip_encryption'
 
-- Login: xxh
SET @pwd = CONVERT (varbinary(256), 0x0100E468E62242CBDF08A7D54B52C0861DFDC407A90C1511979B5FDC7C5CF26F44842A20D8AA2B8460B37F3CFFDC)
EXEC master..sp_addlogin 'xxh', @pwd, @sid = 0x777FBB66A2CD0D4CBE0659A5FE16FEEB, @encryptopt = 'skip_encryption'
 
-- Login: XZHQ
SET @pwd = CONVERT (varbinary(256), 0x0100C020A220F4CB097A3B1C0C750DEC90BBCD7F6E38FA9A0D6BD545EF2153B96CD37C3C1FFA55A923669E02DEA5)
EXEC master..sp_addlogin 'XZHQ', @pwd, @sid = 0x2A7CBFFDF14E314B8FF5A47DBA69D92A, @encryptopt = 'skip_encryption'
 
-- Login: yiwei
SET @pwd = CONVERT (varbinary(256), 0x0100754AE36F8002743812B463E5371093673AFB016612F4F29D533DE57F7B03CCCAF30224A17327680AC05E1E11)
EXEC master..sp_addlogin 'yiwei', @pwd, @sid = 0x4A38E4ECD4C52446A6E09F8F10543BC3, @encryptopt = 'skip_encryption'
 
-- Login: zhangyl2
SET @pwd = CONVERT (varbinary(256), 0x0100DD59E73617A8EFDD4D9B5387A37789F86FBD1C6BE6DE340118A1AD03FAEEF2E8DBF122E24CE9A5C181F40673)
EXEC master..sp_addlogin 'zhangyl2', @pwd, @sid = 0x1E3F33301F20E7439F098543908F8300, @encryptopt = 'skip_encryption'
 
-- Login: zhengbin
SET @pwd = CONVERT (varbinary(256), 0x01000B2AAB41717B975D8834EE275FB2F6A737BE455569BB1F674016F637477A2920AC3F01B1CA2C7A399BFDA978)
EXEC master..sp_addlogin 'zhengbin', @pwd, @sid = 0x61EC085C37E9FD40AEBFB51C8B0B39D0, @encryptopt = 'skip_encryption'
 
-- Login: zhenghz
SET @pwd = CONVERT (varbinary(256), 0x0100A531445A8DEAE6DF857C5922943B096A37345672ADAD04F38DEAE6DF857C5922943B096A37345672ADAD04F3)
EXEC master..sp_addlogin 'zhenghz', @pwd, @sid = 0x95058FFE79D5894C9EABDEBE03420DD7, @encryptopt = 'skip_encryption'
 
 
 
/***** SET DEFAULT DATABASES *****/
 
-- Login:  shenjx1
EXEC master.dbo.sp_defaultdb @loginame= N' shenjx1', @defdb = N'Lenr3'
 
-- Login: aduser
EXEC master.dbo.sp_defaultdb @loginame= N'aduser', @defdb = N'LenovoMobile'
 
-- Login: AppUser
EXEC master.dbo.sp_defaultdb @loginame= N'AppUser', @defdb = N'LenovoData'
 
-- Login: boadmin
EXEC master.dbo.sp_defaultdb @loginame= N'boadmin', @defdb = N'QuestSoftware'
 
-- Login: bomcost
EXEC master.dbo.sp_defaultdb @loginame= N'bomcost', @defdb = N'master'
 
-- Login: BUILTIN\Administrators
--EXEC master.dbo.sp_defaultdb @loginame= N'BUILTIN\Administrators', @defdb = N'master'
 
-- Login: caixyb
EXEC master.dbo.sp_defaultdb @loginame= N'caixyb', @defdb = N'Lenr3'
 
-- Login: checkdate
EXEC master.dbo.sp_defaultdb @loginame= N'checkdate', @defdb = N'Lenr3'
 
-- Login: cs_station
EXEC master.dbo.sp_defaultdb @loginame= N'cs_station', @defdb = N'Visit'
 
-- Login: cswebuser
EXEC master.dbo.sp_defaultdb @loginame= N'cswebuser', @defdb = N'master'
 
-- Login: DBMonitor
EXEC master.dbo.sp_defaultdb @loginame= N'DBMonitor', @defdb = N'master'
 
-- Login: eservice
EXEC master.dbo.sp_defaultdb @loginame= N'eservice', @defdb = N'Lenr3'
 
-- Login: excel_into
EXEC master.dbo.sp_defaultdb @loginame= N'excel_into', @defdb = N'master'
 
-- Login: guoxp
EXEC master.dbo.sp_defaultdb @loginame= N'guoxp', @defdb = N'Lenr3'
 
-- Login: hongqp
EXEC master.dbo.sp_defaultdb @loginame= N'hongqp', @defdb = N'master'
 
-- Login: huifang
EXEC master.dbo.sp_defaultdb @loginame= N'huifang', @defdb = N'LenovoData'
 
-- Login: itsm
EXEC master.dbo.sp_defaultdb @loginame= N'itsm', @defdb = N'LenovoMobile'
 
-- Login: jiabao
EXEC master.dbo.sp_defaultdb @loginame= N'jiabao', @defdb = N'Lenr3'
 
-- Login: JianYan
EXEC master.dbo.sp_defaultdb @loginame= N'JianYan', @defdb = N'Visit'
 
-- Login: jingyi
EXEC master.dbo.sp_defaultdb @loginame= N'jingyi', @defdb = N'LenovoQMSO'
 
-- Login: kefu
EXEC master.dbo.sp_defaultdb @loginame= N'kefu', @defdb = N'Visit'
 
-- Login: kunnr
EXEC master.dbo.sp_defaultdb @loginame= N'kunnr', @defdb = N'Lenr3'
 
-- Login: LEGEND
EXEC master.dbo.sp_defaultdb @loginame= N'LEGEND', @defdb = N'master'
 
-- Login: legendsddbo
EXEC master.dbo.sp_defaultdb @loginame= N'legendsddbo', @defdb = N'Lenr3'
 
-- Login: lenhr
EXEC master.dbo.sp_defaultdb @loginame= N'lenhr', @defdb = N'LENHR'
 
-- Login: lenovojt_user
EXEC master.dbo.sp_defaultdb @loginame= N'lenovojt_user', @defdb = N'LENHR'
 
-- Login: lenr3
EXEC master.dbo.sp_defaultdb @loginame= N'lenr3', @defdb = N'QuestSoftware'
 
-- Login: linkfactory
EXEC master.dbo.sp_defaultdb @loginame= N'linkfactory', @defdb = N'Lenr3'
 
-- Login: lixt
EXEC master.dbo.sp_defaultdb @loginame= N'lixt', @defdb = N'LenovoData'
 
-- Login: lmlec
EXEC master.dbo.sp_defaultdb @loginame= N'lmlec', @defdb = N'QuestSoftware'
 
-- Login: LML-F3576C640AA\sqlserver
--EXEC master.dbo.sp_defaultdb @loginame= N'LML-F3576C640AA\sqlserver', @defdb = N'master'
 
-- Login: load
EXEC master.dbo.sp_defaultdb @loginame= N'load', @defdb = N'Lenr3'
 
-- Login: malz
EXEC master.dbo.sp_defaultdb @loginame= N'malz', @defdb = N'master'
 
-- Login: manhouruser
EXEC master.dbo.sp_defaultdb @loginame= N'manhouruser', @defdb = N'manhourStatistic'
 
-- Login: mesuser
EXEC master.dbo.sp_defaultdb @loginame= N'mesuser', @defdb = N'LENHR'
 
-- Login: pc
EXEC master.dbo.sp_defaultdb @loginame= N'pc', @defdb = N'master'
 
-- Login: QASS
EXEC master.dbo.sp_defaultdb @loginame= N'QASS', @defdb = N'master'
 
-- Login: rb
EXEC master.dbo.sp_defaultdb @loginame= N'rb', @defdb = N'master'
 
-- Login: remoyiwei
EXEC master.dbo.sp_defaultdb @loginame= N'remoyiwei', @defdb = N'LENHR'
 
-- Login: shangwin
EXEC master.dbo.sp_defaultdb @loginame= N'shangwin', @defdb = N'Lenr3'
 
-- Login: shenjx
EXEC master.dbo.sp_defaultdb @loginame= N'shenjx', @defdb = N'Lenr3'
 
-- Login: songhya
EXEC master.dbo.sp_defaultdb @loginame= N'songhya', @defdb = N'master'
 
-- Login: sqladmin
EXEC master.dbo.sp_defaultdb @loginame= N'sqladmin', @defdb = N'master'
 
-- Login: sw_trans
EXEC master.dbo.sp_defaultdb @loginame= N'sw_trans', @defdb = N'Lenr3'
 
-- Login: swwl
EXEC master.dbo.sp_defaultdb @loginame= N'swwl', @defdb = N'master'
 
-- Login: test
EXEC master.dbo.sp_defaultdb @loginame= N'test', @defdb = N'master'
 
-- Login: tmp
EXEC master.dbo.sp_defaultdb @loginame= N'tmp', @defdb = N'Visit'
 
-- Login: unionsoft
EXEC master.dbo.sp_defaultdb @loginame= N'unionsoft', @defdb = N'Visit'
 
-- Login: wspc
EXEC master.dbo.sp_defaultdb @loginame= N'wspc', @defdb = N'LenovoMobile'
 
-- Login: xiaojia
EXEC master.dbo.sp_defaultdb @loginame= N'xiaojia', @defdb = N'QuestSoftware'
 
-- Login: XINGJI
EXEC master.dbo.sp_defaultdb @loginame= N'XINGJI', @defdb = N'master'
 
-- Login: xingjitmp
EXEC master.dbo.sp_defaultdb @loginame= N'xingjitmp', @defdb = N'master'
 
-- Login: XJ
EXEC master.dbo.sp_defaultdb @loginame= N'XJ', @defdb = N'QuestSoftware'
 
-- Login: xujk
EXEC master.dbo.sp_defaultdb @loginame= N'xujk', @defdb = N'Lenr3'
 
-- Login: xxh
EXEC master.dbo.sp_defaultdb @loginame= N'xxh', @defdb = N'Lenr3'
 
-- Login: XZHQ
EXEC master.dbo.sp_defaultdb @loginame= N'XZHQ', @defdb = N'LenovoMobile'
 
-- Login: yiwei
EXEC master.dbo.sp_defaultdb @loginame= N'yiwei', @defdb = N'Lenr3'
 
-- Login: zhangyl2
EXEC master.dbo.sp_defaultdb @loginame= N'zhangyl2', @defdb = N'master'
 
-- Login: zhengbin
EXEC master.dbo.sp_defaultdb @loginame= N'zhengbin', @defdb = N'master'
 
-- Login: zhenghz
EXEC master.dbo.sp_defaultdb @loginame= N'zhenghz', @defdb = N'Lenr3'
 
 
 
/***** SET SERVER ROLES *****/
exec master.dbo.sp_addsrvrolemember @loginame=' shenjx1', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame=' shenjx1', @rolename='securityadmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='securityadmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='serveradmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='setupadmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='processadmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='diskadmin'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='dbcreator'
exec master.dbo.sp_addsrvrolemember @loginame='aduser', @rolename='bulkadmin'
--exec master.dbo.sp_addsrvrolemember @loginame='BUILTIN\Administrators', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='DBMonitor', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='DBMonitor', @rolename='securityadmin'
exec master.dbo.sp_addsrvrolemember @loginame='DBMonitor', @rolename='serveradmin'
exec master.dbo.sp_addsrvrolemember @loginame='DBMonitor', @rolename='bulkadmin'
exec master.dbo.sp_addsrvrolemember @loginame='excel_into', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='hongqp', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='hongqp', @rolename='setupadmin'
exec master.dbo.sp_addsrvrolemember @loginame='legendsddbo', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='legendsddbo', @rolename='securityadmin'
exec master.dbo.sp_addsrvrolemember @loginame='lenhr', @rolename='dbcreator'
--exec master.dbo.sp_addsrvrolemember @loginame='LML-F3576C640AA\sqlserver', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='malz', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='shenjx', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='shenjx', @rolename='securityadmin'
exec master.dbo.sp_addsrvrolemember @loginame='sqladmin', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='xxh', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='xxh', @rolename='bulkadmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='sysadmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='securityadmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='serveradmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='setupadmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='processadmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='diskadmin'
exec master.dbo.sp_addsrvrolemember @loginame='zhangyl2', @rolename='bulkadmin'
